Tabela DictionaryType

Definicja tabeli DictionaryType

Name

DictionaryType

Code

DictionaryType

Comment

 


Lista kolumn tabeli DictionaryType

Name

Code

DictionaryTypeID

DictionaryTypeID

Description

Description

FullName

FullName

ShortName

ShortName

StartDT

StartDT

Code

Code


Kolumna DictionaryTypeID tabeli DictionaryType

Definicja kolumny DictionaryTypeID tabeli DictionaryType

Name

DictionaryTypeID

Code

DictionaryTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Description tabeli DictionaryType

Definicja kolumny Description tabeli DictionaryType

Name

Description

Code

Description

Data Type

VARCHAR2(768)

Mandatory

No

Comment

 


Kolumna FullName tabeli DictionaryType

Definicja kolumny FullName tabeli DictionaryType

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ShortName tabeli DictionaryType

Definicja kolumny ShortName tabeli DictionaryType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna StartDT tabeli DictionaryType

Definicja kolumny StartDT tabeli DictionaryType

Name

StartDT

Code

StartDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Code tabeli DictionaryType

Definicja kolumny Code tabeli DictionaryType

Name

Code

Code

Code

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Lista kluczy tabeli DictionaryType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DictionaryType

Definicja klucza Identifier_1 tabeli DictionaryType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment